This figure illustrates how materialized views work with the SQL Access Advisor:

- First, data is in a warehouse. The warehouse includes materialized views and workloads.

- From the warehouse, data goes to the trace log and the SQL cache.

- From the trace log, to Oracle Trace Manager, then to the SQL Access Advisor.

- From the SQL cache, to the SQL Access Advisor.

- In addition, workload collection can go to the SQL Access Advisor.

- Also, Discoverer or a third-party tool can go to the SQL Access Advisor.